set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=90;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=90; --  每天生成 60 个分区

insert overwrite table jms_dim.dim_ep_center_institutiona_post_dt
select
id
,site_code
,site_name
,code
,name
,institutiona_code
,performance_type
,post_code
,create_by
,create_by_code
,create_by_name
,create_time
,update_by
,update_by_code
,update_by_name
,update_time
,status
,remark
,post_name
,agent_code
,agent_name
,place_type_code
,place_type_name
,rely_institution_code
,rely_institution_name
,calculate_type
,calculate_name
,is_special
,bz_type
,target_effect
,dt
from jms_ods.ep_center_institutiona_post
where dt= '{{ execution_date | cst_ds }}'
 distribute by 1 ;